﻿<%@ Page Language="VB" AutoEventWireup="false" CodeFile="deliveryreport.aspx.vb" Inherits="delivery_deliveryreport" %>

<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
          <ContentTemplate>
            <asp:ScriptManager ID="ScriptManager1" runat="server">
                </asp:ScriptManager>
          
                <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Height="700px" Width="100%">
                <LocalReport ReportPath="delivery\Report3.rdlc">
                    <DataSources>
                        <rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="DataSet1" />
                    </DataSources>
                </LocalReport>
            </rsweb:ReportViewer>
              <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" SelectCommand="SELECT dKey, serial, storename, storeip, guestname, guestaddress, contactno, order_, totalbill, specialins, changefor, status, datesent, datedelivered, timestamp, sender FROM delivery_items WHERE (timestamp BETWEEN @startDate AND @endDate)">
                  <SelectParameters>
                      <asp:QueryStringParameter Name="startDate" QueryStringField="start" />
                      <asp:QueryStringParameter Name="endDate" QueryStringField="end" />
                  </SelectParameters>
              </asp:SqlDataSource>
          </ContentTemplate> 
          </asp:UpdatePanel> 
    </form>
</body>
</html>
